package dao;

import data.User;

public interface UserDAO
{
	public static final String TABLE_NAME = "user";
	
	public static final String COLUMN_NAME_ID = "id";
	public static final String COLUMN_NAME_NICKNAME = "nickname";
	public static final String COLUMN_NAME_USERNAME = "username";
	public static final String COLUMN_NAME_PASSWORD = "password";
	
	
	public User selectByID(int user_id);
	public User selectByUsername(String username);
	public boolean insert(User user);
	public boolean insert(String username, String password);
	public void update(User user);
	public void update(int user_id, String column_name, String value);
	
	public boolean hasUser(int user_id);
	public boolean hasUser(String username);
	public boolean checkUser(String username, String password);
	
}





